MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Geography Type = 100

View and edit SQL

Suggested facets: Department, City, Country, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
377624 SL.28.2013.3.1 0 0 591558 Egyptian Art 19 relief, Ramesses II 26532 Relief of Ramesses II   New Kingdom                         ca. 1279-1213 B.C. -1279 -1213 Painted limestone 55683 15 x 17 in.x 4 in (th) (38.1 x 43.2 cm) Museum Collection Fund Country of Origin|Possibly from 100   | 96   Egypt 104 Northern Upper Egypt 644 Abydos 142             Metropolitan Museum of Art, New York, NY 1
390695 SL.12.2016.34.2 0 0 642111 Islamic Art 9 Bowl 106 Bowl with Epigraphic Band and Signs of the Zodiac                             early 13th century 0 0 Stonepaste; glazed in opaque white, luster-painted 46718 Height: 4 7/16 in. (11.3 cm) Diam. of rim: 7 5/16 in. (18.5 cm) The Ashmolean Museum, Oxford. Presented by Sir Alan Barlow, 1956. (EA1956.58) Country of Origin|Possibly from 100 Kashan 1464 | 96   Iran|Iran 351             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
390731 SL.12.2016.33.5 0 0 642185 Islamic Art 9 Coin; Dinar 26658 Dinar of Sanjar with Honeycomb Pattern                             A.H. 512–29 / A.D. 1118–35 1118 1135 Pale gold 58506 Diam. 7/8 in. (2.2 cm) Weight: 0.082oz. (2.33g) American Numismatic Society, New York (1979.213.1) Country of Origin|Possibly from 100 Balkh 2432 | 96   Afghanistan|Afghanistan 991             Coins 241   Metropolitan Museum of Art, New York, NY 1
390772 SL.12.2016.38.3a, b 0 0 642261 Islamic Art 9 Instrument; globe 26664 Celestial globe                             dated A.H. 540 / A.D. 1144–45 1119 1170 Brass; cast, engraved, inlaid with silver 58536 Height: 10 5/8 in. (27 cm) Diameter: 6 7/8 in. (17.5 cm) Diameter (max): 8 1/2 in. (21.6 cm) Weight: 166.352oz. (4.716 kg) Paris, Louvre Museum, Department of Islamic Art (MAO 824) Country of Origin|Possibly from 100   | 96   Iran|Iran 351             Metal 1   Metropolitan Museum of Art, New York, NY 1
390819 SL.12.2016.23.1 0 0 642352 Islamic Art 9 Folio from an illustrated manuscript 14202 "Design for the Automata of a Perpetual Flute," from the Kitab fi ma'rifat al-hiyal al-handasiyya (Book of the Knowledge of Ingenious Mechanical Devices) by Badi' al-Zaman b. al Razzaz al-Jazari                             dated A.H. 715 / A.D. 1315 1290 1340 Ink, opaque watercolor, and gold on paper 7497 Sheet: 12 3/16 × 8 7/16 in. (31 × 21.5 cm) The al-Sabah Collection, Dar al-Athar al-lslamiyyah, Kuwait (LNS 17 MS) Country of Origin|Possibly from 100   | 96   Syria or Iraq|Syria or Iraq 1014             Works on Paper 170   Metropolitan Museum of Art, New York, NY 1
396025 SL.12.2016.23.18 0 0 649422 Islamic Art 9 Tile panel 14192 Mosaic-Tile Panel with Inscription (from Qur'an 2:286) Once Above a Window of the Interior Dome Courtyard of the Karatay Madrasa                             1251 1251 1251 Stonepaste set in gypsum; glazed 58769 Height: 12 3/8 in. (31.5 cm) Width: 66 1/8 in. (168 cm) The al-Sabah Collection, Dar al-Athar al-lslamiyyah, Kuwait (LNS 234 C) Country of Origin|Possibly from 100 Konya 1538 | 96   Turkey|Turkey 1020             Ceramics-Tiles 776   Metropolitan Museum of Art, New York, NY 1
398766 SL.12.2016.29.5 0 0 653069 Islamic Art 9 Medical tool  26721 Spoon                             11th–12th century 1000 1199 Bronze; cast 44734 Height: 9 in. (22.8 cm) Diameter (Spoon): 1 13/16 in. (4.6 cm) The Museum of History and Local Lore of Mary province of Turkmenistan (KEK 15769) Country of Origin|Possibly from 100 Merv 2461 | 96   Turkmenistan 88             Metal 1   Metropolitan Museum of Art, New York, NY 1
421410 SL.12.2016.5.9 0 0 698045 Islamic Art 9 Tile 101 Tile with a Rosette Once Decorating an Upper Corner of the Mihrab in the Sircali Madrasa                             late 13th century 1250 1299   10 1/4 × 10 1/4 in. (26 × 26 cm) Museum für Islamische Kunst, Staatliche Museen zu Berlin (KONYA99a) Country of Origin|Possibly from 100 Konya 1538 | 96   Turkey|Anatolia 1006             Ceramics-Tiles 776   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 123.126ms · Data license: CC0 · Data source: metmuseum/openaccess